import pandas as pd
# import lxml
# import xlrd

def row_data1():
    table_1_data = pd.read_excel('按城乡分人员数.xls')
    df_1 = table_1_data
    title = df_1.columns.tolist()[1:]
    td_data = []
    for i in range(3):
        td_data.append(df_1[i:i+1].T[i].tolist())
    return title,td_data

def row_data2():
    table_2_data = pd.read_excel('按三次产业分就业人员数.xls')
    df_2 = table_2_data
    title = df_2.columns.tolist()[1:]
    td_data = []
    for i in range(4):
        td_data.append(df_2[i:i+1].T[i].tolist())
    return title,td_data

def row_data3():
    table_3_data = pd.read_excel('城镇登记失业人员数及失业率.xls')
    df_3 = table_3_data
    title = df_3.columns.tolist()[1:]
    td_data = []
    for i in range(2):
        td_data.append(df_3[i:i+1].T[i].tolist())
    return title,td_data

def row_data4():
    table_4_data = pd.read_excel('国内旅游情况.xls')
    df_4 = table_4_data
    title = df_4.columns.tolist()[1:]
    td_data = []
    for i in range(3):
        td_data.append(df_4[i:i+1].T[i].tolist())
    return title,td_data

def row_data5():
    table_5_data = pd.read_excel('外国游客入境数.xls')
    df_5 = table_5_data
    title = df_5.columns.tolist()[1:]
    td_data = []
    for i in range(29):
        td_data.append(df_5[i:i+1].T[i].tolist())
    return title,td_data

def row_data6():
    table_6_data = pd.read_excel('旅游业发展情况.xls')
    df_6 = table_6_data
    title = df_6.columns.tolist()[1:]
    td_data = []
    for i in range(2):
        td_data.append(df_6[i:i+1].T[i].tolist())
    return title,td_data